CREATE TABLE "iws_merge_task"
(
    "id"               VARCHAR(50) PRIMARY KEY,
    "task_id"          VARCHAR(50) NULL DEFAULT NULL,
    "task_status"      INT         NULL DEFAULT NULL,
    "task_start"       VARCHAR(50) NULL DEFAULT NULL,
    "task_end"         VARCHAR(50) NULL DEFAULT NULL,
    "container_status" INT         NULL DEFAULT NULL,
    "container_code"   VARCHAR(50) NULL DEFAULT NULL UNIQUE,
    "work_ip"          VARCHAR(50) NULL DEFAULT NULL,
    "floor"            VARCHAR(50) NULL DEFAULT NULL,
    "good_type"        VARCHAR(50) NULL DEFAULT NULL,
    "create_name"      VARCHAR(50) NULL DEFAULT NULL,
    "create_date"      DATETIME    NULL DEFAULT NULL,
    "start_date"       DATETIME    NULL DEFAULT NULL,
);
exec sp_addextendedproperty 'MS_Description', N'任务单号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'id'
go
exec sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'task_status'
go
exec sp_addextendedproperty 'MS_Description', N'任务起点储位', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'task_start'
go
exec sp_addextendedproperty 'MS_Description', N'任务终点储位', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'task_end'
go
exec sp_addextendedproperty 'MS_Description', N'载具状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'container_status'
go
exec sp_addextendedproperty 'MS_Description', N'载具码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'container_code'
go


exec sp_addextendedproperty 'MS_Description', N'仓库', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'floor'
go
exec sp_addextendedproperty 'MS_Description', N'工位IP', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'work_ip'
go
exec sp_addextendedproperty 'MS_Description', N'货位类型', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'good_type'
go
exec sp_addextendedproperty 'MS_Description', N'建单账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'create_name'
go
exec sp_addextendedproperty 'MS_Description', N'建单时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'create_date'
go
exec sp_addextendedproperty 'MS_Description', N'开始时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_merge_task', 'COLUMN', 'start_date'
go